Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	2628
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	236.2 KiB
Average record size in memory	92.0 B

Variable types

Numeric	12
Categorical	3
DateTime	1

Alerts

`monto_credito` is highly correlated with `saldo_capital` and 3 other fields	High correlation
`saldo_capital` is highly correlated with `monto_credito` and 3 other fields	High correlation
`saldo_Ahorro` is highly correlated with `monto_credito` and 2 other fields	High correlation
`Antiguedad_en_meses` is highly correlated with `monto_credito` and 2 other fields	High correlation
`plazo_dias` is highly correlated with `monto_credito` and 1 other fields	High correlation
`monto_credito` is highly correlated with `saldo_capital` and 2 other fields	High correlation
`saldo_capital` is highly correlated with `monto_credito` and 2 other fields	High correlation
`saldo_Ahorro` is highly correlated with `monto_credito` and 2 other fields	High correlation
`Antiguedad_en_meses` is highly correlated with `saldo_Ahorro`	High correlation
`plazo_dias` is highly correlated with `monto_credito` and 1 other fields	High correlation
`Patrimonio` is highly correlated with `tasa` and 1 other fields	High correlation
`Ingresos_Mensuales` is highly correlated with `tasa` and 1 other fields	High correlation
`No_hijos` is highly correlated with `tasa` and 1 other fields	High correlation
`monto_credito` is highly correlated with `tasa` and 2 other fields	High correlation
`tasa` is highly correlated with `Patrimonio` and 4 other fields	High correlation
`saldo_capital` is highly correlated with `monto_credito` and 2 other fields	High correlation
`saldo_Ahorro` is highly correlated with `saldo_capital` and 1 other fields	High correlation
`Antiguedad_en_meses` is highly correlated with `Max_dias_mora`	High correlation
`Max_dias_mora` is highly correlated with `Patrimonio` and 7 other fields	High correlation
`Id_Cliente` is highly correlated with `Ciudad` and 1 other fields	High correlation
`Ciudad` is highly correlated with `Id_Cliente` and 1 other fields	High correlation
`Patrimonio` is highly correlated with `Id_Cliente` and 1 other fields	High correlation
`fecha_ult_desembolso` is highly correlated with `Ciudad` and 9 other fields	High correlation
`monto_credito` is highly correlated with `fecha_ult_desembolso` and 4 other fields	High correlation
`tasa` is highly correlated with `fecha_ult_desembolso` and 1 other fields	High correlation
`saldo_capital` is highly correlated with `fecha_ult_desembolso` and 4 other fields	High correlation
`saldo_Ahorro` is highly correlated with `fecha_ult_desembolso` and 5 other fields	High correlation
`Antiguedad_en_meses` is highly correlated with `fecha_ult_desembolso` and 3 other fields	High correlation
`Max_dias_mora` is highly correlated with `fecha_ult_desembolso`	High correlation
`plazo_dias` is highly correlated with `fecha_ult_desembolso` and 3 other fields	High correlation
`Edad` is highly correlated with `fecha_ult_desembolso`	High correlation
`Ingresos_Mensuales` is highly skewed (γ1 = 24.53368732)	Skewed
`Id_Cliente` is uniformly distributed	Uniform
`Id_Cliente` has unique values	Unique
`saldo_Ahorro` has 109 (4.1%) zeros	Zeros
`Max_dias_mora` has 2224 (84.6%) zeros	Zeros

Reproduction

Analysis started	2022-04-03 18:31:38.266292
Analysis finished	2022-04-03 18:34:38.349179
Duration	3 minutes and 0.08 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Id_Cliente
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	2628
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	218268.5

Minimum	216955
Maximum	219582
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.7 KiB

Quantile statistics

Minimum	216955
5-th percentile	217086.35
Q1	217611.75
median	218268.5
Q3	218925.25
95-th percentile	219450.65
Maximum	219582
Range	2627
Interquartile range (IQR)	1313.5

Descriptive statistics

Standard deviation	758.7825776
Coefficient of variation (CV)	0.003476372347
Kurtosis	-1.2
Mean	218268.5
Median Absolute Deviation (MAD)	657
Skewness	0
Sum	573609618
Variance	575751
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
216966	1	< 0.1%
217451	1	< 0.1%
219558	1	< 0.1%
218213	1	< 0.1%
218465	1	< 0.1%
218717	1	< 0.1%
219016	1	< 0.1%
219183	1	< 0.1%
219320	1	< 0.1%
219443	1	< 0.1%
Other values (2618)	2618	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
216955	1	< 0.1%
216956	1	< 0.1%
216957	1	< 0.1%
216958	1	< 0.1%
216959	1	< 0.1%
216960	1	< 0.1%
216961	1	< 0.1%
216962	1	< 0.1%
216963	1	< 0.1%
216964	1	< 0.1%

Value	Count	Frequency (%)
219582	1	< 0.1%
219581	1	< 0.1%
219580	1	< 0.1%
219579	1	< 0.1%
219578	1	< 0.1%
219577	1	< 0.1%
219576	1	< 0.1%
219575	1	< 0.1%
219574	1	< 0.1%
219573	1	< 0.1%

Ciudad
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	20.7 KiB

Cali	756
Bogotá	654
Cartagena	627
Barranquilla	591

Length

Max length	12
Median length	6
Mean length	7.489726027
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Barranquilla
2nd row	Barranquilla
3rd row	Barranquilla
4th row	Barranquilla
5th row	Barranquilla

Common Values

Value	Count	Frequency (%)
Cali	756	28.8%
Bogotá	654	24.9%
Cartagena	627	23.9%
Barranquilla	591	22.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
cali	756	28.8%
bogotá	654	24.9%
cartagena	627	23.9%
barranquilla	591	22.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Patrimonio
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1079
Distinct (%)	41.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48824658.48

Minimum	96817
Maximum	99901000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	96817
5-th percentile	6778897.05
Q1	24284500
median	48767000
Q3	72493000
95-th percentile	93690900
Maximum	99901000
Range	99804183
Interquartile range (IQR)	48208500

Descriptive statistics

Standard deviation	28098004.76
Coefficient of variation (CV)	0.5754879938
Kurtosis	-1.155972711
Mean	48824658.48
Median Absolute Deviation (MAD)	24256500
Skewness	0.06271137545
Sum	1.283112025 × 10¹¹
Variance	7.894978714 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42078698	20	0.8%
84578000	20	0.8%
50000000	18	0.7%
19380000	15	0.6%
18392000	11	0.4%
77506000	7	0.3%
83900000	6	0.2%
54515000	6	0.2%
59174000	4	0.2%
10715000	4	0.2%
Other values (1069)	2517	95.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
96817	1	< 0.1%
191077	1	< 0.1%
236802	1	< 0.1%
327170	1	< 0.1%
335448	1	< 0.1%
495559	1	< 0.1%
607578	1	< 0.1%
652714	1	< 0.1%
778071	1	< 0.1%
879060	1	< 0.1%

Value	Count	Frequency (%)
99901000	3	0.1%
99890340	1	< 0.1%
99833000	3	0.1%
99830010	2	0.1%
99615000	3	0.1%
99609000	3	0.1%
99399000	3	0.1%
99376000	3	0.1%
99360000	4	0.2%
99116000	3	0.1%

Ingresos_Mensuales
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	884
Distinct (%)	33.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1499859.435

Minimum	421263
Maximum	28336624
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	421263
5-th percentile	774589
Q1	1185693
median	1493587
Q3	1768731
95-th percentile	2166280
Maximum	28336624
Range	27915361
Interquartile range (IQR)	583038

Descriptive statistics

Standard deviation	669294.061
Coefficient of variation (CV)	0.4462378576
Kurtosis	983.5742844
Mean	1499859.435
Median Absolute Deviation (MAD)	298457
Skewness	24.53368732
Sum	3941630595
Variance	4.479545401 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
861085	78	3.0%
774587	40	1.5%
747054	38	1.4%
774589	30	1.1%
774851	18	0.7%
1689669	4	0.2%
1586433	4	0.2%
1744197	4	0.2%
960591	4	0.2%
1628879	4	0.2%
Other values (874)	2404	91.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
421263	1	< 0.1%
437465	1	< 0.1%
483633	1	< 0.1%
521160	1	< 0.1%
563316	1	< 0.1%
667402	3	0.1%
671241	3	0.1%
677193	3	0.1%
686453	3	0.1%
688114	3	0.1%

Value	Count	Frequency (%)
28336624	1	< 0.1%
2336623	1	< 0.1%
2336622	1	< 0.1%
2326144	2	0.1%
2324651	1	< 0.1%
2319325	2	0.1%
2312279	1	< 0.1%
2310578	2	0.1%
2308736	3	0.1%
2308470	3	0.1%

No_hijos
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	20.7 KiB

0	932
2	872
1	816
3	7
4	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	1
2nd row	2
3rd row	0
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
0	932	35.5%
2	872	33.2%
1	816	31.1%
3	7	0.3%
4	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	932	35.5%
2	872	33.2%
1	816	31.1%
3	7	0.3%
4	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

oficina
Real number (ℝ_≥0)

Distinct	29
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5461.408295

Minimum	4003
Maximum	7064
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.7 KiB

Quantile statistics

Minimum	4003
5-th percentile	4005
Q1	4017
median	4054
Q3	7030
95-th percentile	7064
Maximum	7064
Range	3061
Interquartile range (IQR)	3013

Descriptive statistics

Standard deviation	1504.387868
Coefficient of variation (CV)	0.2754578648
Kurtosis	-1.993230415
Mean	5461.408295
Median Absolute Deviation (MAD)	51
Skewness	0.08843011358
Sum	14352581
Variance	2263182.858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
4010	325	12.4%
7025	285	10.8%
7032	275	10.5%
4024	218	8.3%
7064	197	7.5%
4011	155	5.9%
4050	137	5.2%
4005	103	3.9%
7030	101	3.8%
4031	93	3.5%
Other values (19)	739	28.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4003	64	2.4%
4005	103	3.9%
4010	325	12.4%
4011	155	5.9%
4014	3	0.1%
4017	17	0.6%
4024	218	8.3%
4025	57	2.2%
4030	82	3.1%
4031	93	3.5%

Value	Count	Frequency (%)
7064	197	7.5%
7059	30	1.1%
7051	20	0.8%
7046	19	0.7%
7044	3	0.1%
7041	21	0.8%
7039	19	0.7%
7038	55	2.1%
7032	275	10.5%
7030	101	3.8%

fecha_ult_desembolso
Date

HIGH CORRELATION

Distinct	100
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Memory size	20.7 KiB

Minimum	2017-01-04 00:00:00
Maximum	2017-12-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

monto_credito
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	233
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2211341.394

Minimum	300000
Maximum	9800000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	300000
5-th percentile	500000
Q1	1031210
median	2000000
Q3	2896255
95-th percentile	5534420
Maximum	9800000
Range	9500000
Interquartile range (IQR)	1865045

Descriptive statistics

Standard deviation	1666275.124
Coefficient of variation (CV)	0.7535132877
Kurtosis	3.849787996
Mean	2211341.394
Median Absolute Deviation (MAD)	961115
Skewness	1.784314133
Sum	5811405183
Variance	2.776472788 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000000	289	11.0%
1500000	162	6.2%
1000000	156	5.9%
3000000	126	4.8%
5000000	91	3.5%
800000	87	3.3%
4000000	84	3.2%
500000	73	2.8%
2500000	64	2.4%
1200000	53	2.0%
Other values (223)	1443	54.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
300000	18	0.7%
320000	10	0.4%
330000	3	0.1%
346560	3	0.1%
350000	6	0.2%
370000	3	0.1%
400000	25	1.0%
438800	6	0.2%
444000	3	0.1%
446560	3	0.1%

Value	Count	Frequency (%)
9800000	1	< 0.1%
9500000	14	0.5%
9458720	3	0.1%
9000000	13	0.5%
8900000	5	0.2%
8000000	7	0.3%
7307700	3	0.1%
7279360	4	0.2%
7000000	3	0.1%
6900000	9	0.3%

tasa
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	16
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.66285388

Minimum	0.21
Maximum	33.93
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.7 KiB

Quantile statistics

Minimum	0.21
5-th percentile	0.3
Q1	33.93
median	33.93
Q3	33.93
95-th percentile	33.93
Maximum	33.93
Range	33.72
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.01441028
Coefficient of variation (CV)	0.4191630857
Kurtosis	1.734011528
Mean	28.66285388
Median Absolute Deviation (MAD)	0
Skewness	-1.922999514
Sum	75325.98
Variance	144.3460544
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
33.93	2065	78.6%
0.3	367	14.0%
33.18	88	3.3%
28.73	33	1.3%
28.07	15	0.6%
0.28	12	0.5%
0.21	12	0.5%
31.89	6	0.2%
32.09	6	0.2%
21.94	6	0.2%
Other values (6)	18	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.21	12	0.5%
0.23	3	0.1%
0.25	3	0.1%
0.28	12	0.5%
0.3	367	14.0%
21.94	6	0.2%
22.6	3	0.1%
25.12	3	0.1%
28.07	15	0.6%
28.73	33	1.3%

Value	Count	Frequency (%)
33.93	2065	78.6%
33.18	88	3.3%
32.88	3	0.1%
32.27	3	0.1%
32.09	6	0.2%
31.89	6	0.2%
28.73	33	1.3%
28.07	15	0.6%
25.12	3	0.1%
22.6	3	0.1%

saldo_capital
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	731
Distinct (%)	27.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1621322.632

Minimum	18714
Maximum	9925519
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	18714
5-th percentile	239561
Q1	649156
median	1105952.5
Q3	2093885.25
95-th percentile	4764789
Maximum	9925519
Range	9906805
Interquartile range (IQR)	1444729.25

Descriptive statistics

Standard deviation	1452214.048
Coefficient of variation (CV)	0.8956971416
Kurtosis	5.603847279
Mean	1621322.632
Median Absolute Deviation (MAD)	639768.5
Skewness	2.060017777
Sum	4260835878
Variance	2.10892564 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000000	34	1.3%
800000	29	1.1%
2000000	28	1.1%
1500000	27	1.0%
2093120	26	1.0%
1046560	25	1.0%
2500000	25	1.0%
662393	16	0.6%
500000	15	0.6%
2069840	15	0.6%
Other values (721)	2388	90.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18714	3	0.1%
40642	4	0.2%
75942	3	0.1%
79398	3	0.1%
94241	3	0.1%
94933	3	0.1%
95896	3	0.1%
96841	3	0.1%
99290	3	0.1%
100600	3	0.1%

Value	Count	Frequency (%)
9925519	3	0.1%
9647385	3	0.1%
9000000	2	0.1%
8840686	3	0.1%
8443599	3	0.1%
8253065	3	0.1%
7810084	3	0.1%
7800000	1	< 0.1%
7224190	3	0.1%
6915555	3	0.1%

saldo_Ahorro
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	784
Distinct (%)	29.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28469.95396

Minimum	0
Maximum	159843
Zeros	109
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	20.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1358
Q1	9474
median	20631
Q3	39369
95-th percentile	83782
Maximum	159843
Range	159843
Interquartile range (IQR)	29895

Descriptive statistics

Standard deviation	26320.43199
Coefficient of variation (CV)	0.9244985793
Kurtosis	3.748261407
Mean	28469.95396
Median Absolute Deviation (MAD)	12431.5
Skewness	1.743781837
Sum	74819039
Variance	692765140
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	109	4.1%
63658	13	0.5%
20370	10	0.4%
20631	10	0.4%
19713	9	0.3%
38195	9	0.3%
24642	9	0.3%
53297	8	0.3%
53890	7	0.3%
18262	7	0.3%
Other values (774)	2437	92.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	109	4.1%
571	3	0.1%
662	3	0.1%
884	3	0.1%
921	3	0.1%
1066	1	< 0.1%
1086	3	0.1%
1114	3	0.1%
1178	3	0.1%
1358	3	0.1%

Value	Count	Frequency (%)
159843	3	0.1%
158582	3	0.1%
152113	3	0.1%
145541	2	0.1%
137405	3	0.1%
137084	2	0.1%
136479	3	0.1%
136343	3	0.1%
132549	3	0.1%
123216	3	0.1%

Antiguedad_en_meses
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	110
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.20890411

Minimum	11
Maximum	120
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	11
5-th percentile	12
Q1	43
median	82
Q3	117
95-th percentile	118
Maximum	120
Range	109
Interquartile range (IQR)	74

Descriptive statistics

Standard deviation	36.80815971
Coefficient of variation (CV)	0.482990277
Kurtosis	-1.234072337
Mean	76.20890411
Median Absolute Deviation (MAD)	35
Skewness	-0.3823715749
Sum	200277
Variance	1354.840621
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
117	561	21.3%
12	201	7.6%
118	99	3.8%
82	81	3.1%
95	59	2.2%
77	48	1.8%
34	45	1.7%
62	44	1.7%
94	43	1.6%
78	42	1.6%
Other values (100)	1405	53.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	12	0.5%
12	201	7.6%
13	21	0.8%
14	9	0.3%
15	3	0.1%
16	6	0.2%
17	22	0.8%
18	4	0.2%
19	3	0.1%
20	13	0.5%

Value	Count	Frequency (%)
120	14	0.5%
119	26	1.0%
118	99	3.8%
117	561	21.3%
116	41	1.6%
115	6	0.2%
114	3	0.1%
113	34	1.3%
112	8	0.3%
111	9	0.3%

Max_dias_mora
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	49
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.732115677

Minimum	0
Maximum	96
Zeros	2224
Zeros (%)	84.6%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	27
Maximum	96
Range	96
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	14.97872377
Coefficient of variation (CV)	3.165333392
Kurtosis	17.39820812
Mean	4.732115677
Median Absolute Deviation (MAD)	0
Skewness	4.062429051
Sum	12436
Variance	224.3621658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	2224	84.6%
26	38	1.4%
12	38	1.4%
11	27	1.0%
4	27	1.0%
90	25	1.0%
20	23	0.9%
8	15	0.6%
15	15	0.6%
25	15	0.6%
Other values (39)	181	6.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2224	84.6%
4	27	1.0%
6	9	0.3%
7	3	0.1%
8	15	0.6%
9	3	0.1%
10	9	0.3%
11	27	1.0%
12	38	1.4%
15	15	0.6%

Value	Count	Frequency (%)
96	1	< 0.1%
93	1	< 0.1%
92	1	< 0.1%
90	25	1.0%
89	4	0.2%
88	4	0.2%
83	3	0.1%
80	2	0.1%
78	3	0.1%
73	4	0.2%

plazo_dias
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	27
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	653.2191781

Minimum	144
Maximum	1080
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	144
5-th percentile	360
Q1	450
median	600
Q3	720
95-th percentile	1080
Maximum	1080
Range	936
Interquartile range (IQR)	270

Descriptive statistics

Standard deviation	259.9916002
Coefficient of variation (CV)	0.3980158712
Kurtosis	-0.9399454714
Mean	653.2191781
Median Absolute Deviation (MAD)	150
Skewness	0.3790515569
Sum	1716660
Variance	67595.63219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
720	659	25.1%
1080	492	18.7%
540	465	17.7%
360	456	17.4%
450	209	8.0%
900	110	4.2%
300	62	2.4%
600	39	1.5%
180	29	1.1%
240	15	0.6%
Other values (17)	92	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
144	10	0.4%
180	29	1.1%
210	6	0.2%
240	15	0.6%
270	6	0.2%
300	62	2.4%
330	3	0.1%
360	456	17.4%
420	7	0.3%
450	209	8.0%

Value	Count	Frequency (%)
1080	492	18.7%
1050	3	0.1%
1020	3	0.1%
990	3	0.1%
960	4	0.2%
900	110	4.2%
840	6	0.2%
780	4	0.2%
750	3	0.1%
720	659	25.1%

Edad
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	50
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.79642314

Minimum	20
Maximum	69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.4 KiB

Quantile statistics

Minimum	20
5-th percentile	22
Q1	31
median	43
Q3	56
95-th percentile	67
Maximum	69
Range	49
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.21034122
Coefficient of variation (CV)	0.324463511
Kurtosis	-1.184097966
Mean	43.79642314
Median Absolute Deviation (MAD)	12
Skewness	0.1050417052
Sum	115097
Variance	201.9337976
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	112	4.3%
28	105	4.0%
27	81	3.1%
53	79	3.0%
38	75	2.9%
35	71	2.7%
22	69	2.6%
31	67	2.5%
62	62	2.4%
46	61	2.3%
Other values (40)	1846	70.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	38	1.4%
21	51	1.9%
22	69	2.6%
23	31	1.2%
24	34	1.3%
25	55	2.1%
26	52	2.0%
27	81	3.1%
28	105	4.0%
29	32	1.2%

Value	Count	Frequency (%)
69	35	1.3%
68	58	2.2%
67	57	2.2%
66	45	1.7%
65	42	1.6%
64	55	2.1%
63	53	2.0%
62	62	2.4%
61	42	1.6%
60	35	1.3%

Acepta_Campaña
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.7 KiB

0	1322
1	1306

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	1322	50.3%
1	1306	49.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	1322	50.3%
1	1306	49.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Id_Cliente	Ciudad	Patrimonio	Ingresos_Mensuales	No_hijos	oficina	fecha_ult_desembolso	monto_credito	tasa	saldo_capital	saldo_Ahorro	Antiguedad_en_meses	plazo_dias	Edad	Acepta_Campaña
0	216966	Barranquilla	13224000	2042480	1	4024	2017-05-14	1500000	33.93	1357387	33438	12	900	50	1
1	216967	Barranquilla	13380000	1513835	2	4011	2017-02-05	1500000	33.93	392262	0	12	540	59	1
2	216978	Barranquilla	17320000	1594497	0	7032	2017-02-07	1064170	0.30	211724	0	12	540	63	1
3	216979	Barranquilla	17439000	1104406	2	7032	2017-09-05	2338552	0.30	828993	0	12	720	55	1
4	217028	Barranquilla	41366000	1988538	2	7025	2017-07-06	2385560	33.93	1997956	0	12	720	45	0
5	217029	Barranquilla	41771000	1690652	1	7032	2017-11-06	4000000	0.30	1538055	8844	12	720	55	1
6	217044	Barranquilla	49007000	868070	0	7025	2017-04-20	2300000	33.93	2081267	0	12	720	37	1
7	217067	Barranquilla	57815000	1338413	2	4005	2017-09-06	1200000	33.18	363970	0	12	450	38	1
8	217074	Barranquilla	61457000	2024862	2	4014	2017-05-14	2000000	25.12	1005056	132549	12	900	69	1
9	217077	Barranquilla	63614000	1135835	0	7025	2017-06-25	1500000	33.93	1329227	13104	12	450	69	1

Last rows

	Id_Cliente	Ciudad	Patrimonio	Ingresos_Mensuales	No_hijos	oficina	fecha_ult_desembolso	monto_credito	tasa	saldo_capital	saldo_Ahorro	Antiguedad_en_meses	Max_dias_mora	plazo_dias	Edad	Acepta_Campaña
2618	219271	Cartagena	20080000	1555351	1	4005	2017-04-07	800000	28.07	680293	29154	119	90	360	61	1
2619	217677	Bogotá	62408000	1613334	0	7019	2017-08-05	4000000	0.21	1972176	41874	119	7	1080	34	0
2620	217895	Bogotá	62408000	747054	2	7019	2017-08-05	4000000	0.21	1972176	41874	119	7	1080	34	1
2621	218113	Bogotá	62408000	1613334	2	7019	2017-08-05	4000000	0.21	1972176	41874	119	7	1080	34	1
2622	217716	Bogotá	81537000	2149601	0	4003	2017-04-13	9000000	33.93	7810084	18603	119	0	1080	53	0
2623	217934	Bogotá	81537000	747054	0	4003	2017-04-13	9000000	33.93	7810084	18603	120	0	1080	53	1
2624	218152	Bogotá	81537000	2149601	0	4003	2017-04-13	8900000	33.93	7810084	18603	120	0	1080	53	1
2625	217713	Bogotá	84578000	1952025	2	4030	2017-04-29	9000000	33.93	9000000	19713	120	0	720	52	0
2626	217931	Bogotá	79817000	747054	2	4030	2017-04-29	9000000	33.93	9000000	19713	120	0	720	52	1
2627	218149	Bogotá	79817000	1952025	2	4030	2017-04-29	8900000	33.93	7800000	19713	120	0	720	52	1

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows